<?php

class UsersFixture {
	
	public $tableName = 'users';
	
	public $createSql = "CREATE  TABLE IF NOT EXISTS `users` (
	  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
	  `username` VARCHAR(32) NOT NULL,
	  `password` VARCHAR(32) NOT NULL,
	  `created_date` DATETIME NOT NULL,
	  `updated_date` DATETIME NOT NULL,
	  `deleted_date` DATETIME NULL,
	  PRIMARY KEY (`id`) )
	ENGINE = InnoDB";
	
	public $data = array(
		array(
			'id'			=>	1,
			'username'		=>	'test_user_1',
			'password'		=>	'password',
			'created_date'	=> '2010-09-01 12:34:55',
			'update_date'	=>	'2010-09-01 12:34:55',
			'deleted_date'	=>	'',
		),
		array(
			'id'			=>	2,
			'username'		=>	'test_user_2',
			'password'		=>	'password',
			'created_date'	=> '2010-10-01 12:34:55',
			'update_date'	=>	'2010-11-01 12:34:55',
			'deleted_date'	=>	'2010-11-01 12:34:55',
		),
		array(
			'id'			=>	3,
			'username'		=>	'test_user_3',
			'password'		=>	'password',
			'created_date'	=> '2010-09-12 12:34:55',
			'update_date'	=>	'2010-09-13 12:34:55',
			'deleted_date'	=>	'',
		),
	);
	
}